insert overwrite table yl_ods.yl_cn_mysql_lmdm_sys_network partition(dt)
select
      id
      ,null as name
      ,code
      ,signature_code
      ,cn_name
      ,en_name
      ,country_id
      ,country_code
      ,country_desc
      ,country_three_code
      ,regional_id
      ,regional_desc
      ,area_info_id
      ,area_info_desc
      ,provider_id
      ,provider_desc
      ,city_id
      ,city_desc
      ,area_id
      ,area_desc
      ,township_id
      ,null as principal
      ,null as mobile
      ,null as telephone
      ,parent_network_id
      ,parent_network_code
      ,parent_network_name
      ,financial_center_id
      ,financial_center_code
      ,financial_center_desc
      ,function_type_id
      ,function_type_desc
      ,type_id
      ,type_desc
      ,institutional_level_id
      ,institutional_level_desc
      ,max_collection_money
      ,settlement_destination_id
      ,settlement_destination_desc
      ,is_collection_identifier
      ,is_distribution_center
      ,business_model_id
      ,business_model_desc
      ,local_currency_id
      ,local_currency_code
      ,local_currency_desc
      ,is_financial_center
      ,is_waybill_identification
      ,is_to_payment
      ,is_visibility
      ,is_enable
      ,is_leaf
      ,is_delete
      ,null as address
      ,null as business_principal
      ,null as business_telephone
      ,null as customer_service_principal
      ,null as customer_service_telephone
      ,longitude
      ,latitude
      ,create_by
      ,update_by
      ,create_by_name
      ,update_by_name
      ,create_time
      ,update_time
      ,version
      ,sort
      ,remark
      ,path
      ,is_receiving
      ,is_dispatch
      ,zip_code
      ,start_business_time
      ,end_business_time
      ,last_update_time_sync
      ,coordinate
      ,subordinate_agent
      ,is_first_network_settle
      ,simple_name
      ,is_first_franchisee
      ,is_second_franchisee
      ,is_entrepot
      ,to_payment_limit
      ,opening_type
      ,opening_time
      ,is_retrogression
      ,is_suspend
      ,leaving_time
      ,dt
from jms_ods.yl_cn_mysql_lmdm_sys_network
where dt = '{{ execution_date | cst_ds }}' ;
